Bar: # of Applicants vs YoY 15
# of Applicants vs YoY
Create New Worksheet
Click New Worksheet, Rename it to '# of Applicants vs YoY', Double click title to Edit format. (Size 11, Bold)
Create Bar chart
Drag and Drop Region in Columns and Applicants in Rows, Click descending order icon, Bring in cc. YoY Applicants and cc. YoY Units Available to the right axis, Change Marks (SUM(Applicants) to Bar, Measure Values to line), Fit Entire view, Right Click to Edit axis -remove titles.
See gif
Create Drill-through
Drag and Drop the Region & State pill, Hide field name, Uncheck show header, Go to Worksheet, Select Actions, Dialog box opens - Add filter, Select Change Parameter, Update Empty Parameter, click OK, Click on the Drop down Arrow on the Region & State pill, Select Sort, nested, Descending, Field name is Applicants.
See gif
Color and Format
Edit Color Double click to edit with given Code (Applicants #5c6068, cc. YoY Applicants #1f77b4, cc. YoY Units Available #c16941 ), Right click on sheet space, select format to edit, Click on the Right axis to format and edit the values.
See gif
Date Filter and Tooltip
Drop Year of Date to filter shelf, Select Range, 'Add to Context', Select ALL, Drag and Drop cc. YoY Applicants and cc. YoY Units Available to Tooltip, Right click on each to Format to Percentage. Click tooltip and Add
<Region>
Applicants: <SUM(Applicants)>
cc.YoY Units Available: <AGG(cc.YoY Units Available)>
cc.YoY Applicants: <AGG(cc.YoY Applicants)>
Click OK
See gif
Parameter and Drill down: https://www.youtube.com/watch?v=JWS71vSjUj0